USE [GLP]
GO

/****** Object:  View [dbo].[App_Precios]    Script Date: 10/24/2012 13:01:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW [dbo].[App_Precios]
AS
SELECT     lp.cd_comercio, lp.nm_comercio, lp.cd_proveedor, lp.nm_proveedor, lp.id_lista, art.codigo, art.descripcion, art.precio AS precio_bruto, 
                      ISNULL(dbo.getPrecioConDcto(art.id_articulo, lp.id_lista), art.precio) AS precio_neto
FROM         dbo.App_lista_precios AS lp LEFT OUTER JOIN
                      dbo.App_articulo AS art ON art.id_entidad = lp.cd_proveedor

GO


